﻿CREATE TABLE [dbo].[Projects] (
    [ProjectID]          INT             IDENTITY (1, 1) NOT NULL,
    [Name]               NVARCHAR (50)   NOT NULL,
    [Description]        NVARCHAR (1024) NULL,
    [ManagerUserID]      INT             NULL,
    [EstCompletionDate]  DATETIME        NULL,
    [EstDuration]        DECIMAL (10, 2) NULL,
    [CreationDate]       DATETIME        NOT NULL,
    [StatusID]           INT             NOT NULL,
    [ProjectTypeID]      INT             NOT NULL,
    [BilledAsOf]         DATETIME        NULL,
    [ActivelyUsed]       BIT             NOT NULL,
    [RevenueTypeID]      INT             NOT NULL,
    [ProjectCode]        NVARCHAR (50)   NULL,
    [BillingFrequencyID] INT             NOT NULL
);

